﻿CREATE TABLE [dbo].[PersonSecurityRole]
(
	[SecurityRole] [uniqueidentifier] DEFAULT newid() NOT NULL, -- FK to SecurityRole
	[PersonId] [uniqueidentifier] DEFAULT newid() NOT NULL, -- FK to Person
	[CreatedBy] [uniqueidentifier] NULL, -- FK to Person
	[CreatedOn] [datetime] DEFAULT getdate() NOT NULL

CONSTRAINT PK_PersonSecurityRole PRIMARY KEY CLUSTERED 
(
	[SecurityRole] ASC,
	[PersonId] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
